﻿CREATE VIEW [dbo].[vwProjectMembers]
AS
SELECT     dbo.ProjectMembers.ProjectID, dbo.ProjectMembers.UserID, dbo.ProjectMembers.StartDate, dbo.ProjectMembers.EndDate, dbo.ProjectMembers.HourlyRate, 
                      dbo.Users.UserName, dbo.Users.RoleID, dbo.Users.FullName, dbo.Users.IsActive, dbo.Roles.Name
FROM         dbo.ProjectMembers INNER JOIN
                      dbo.Users ON dbo.ProjectMembers.UserID = dbo.Users.UserID AND dbo.ProjectMembers.UserID = dbo.Users.UserID INNER JOIN
                      dbo.Roles ON dbo.Users.RoleID = dbo.Roles.RoleID;

